class ModifyEvent < ActiveRecord::Migration
  def self.up
    execute 'ALTER TABLE `events` ADD COLUMN `slideshow_id` INT(11) NULL'
    execute 'ALTER TABLE `events` ADD COLUMN `video_link` VARCHAR(255) NULL'
    execute 'ALTER TABLE `events` CHANGE `name` `title` VARCHAR(255) NOT NULL'
    execute 'ALTER TABLE `events` ADD COLUMN `author_id` INT(11) NULL'
    execute 'ALTER TABLE `events` DROP COLUMN `country_id`'
    execute 'ALTER TABLE `events` DROP COLUMN `region_id`'
  end

  def self.down
    execute 'ALTER TABLE `events` DROP COLUMN `video_link`'
    execute 'ALTER TABLE `events` DROP COLUMN `slideshow_id`'
    execute 'ALTER TABLE `events` CHANGE `title` `name` VARCHAR(255) NOT NULL'
    execute 'ALTER TABLE `events` ADD COLUMN `author_id` INT(11) NULL'   
 end
end
